Prepare Data for Exploration Weekly challenge 3 Quiz Answer

Prepare Data for Exploration Weekly challenge 3 Quiz Answer

Go to this Course

In this article i am gone to share Coursera Course: Prepare Data for Exploration Weekly challenge 3 Quiz Answer with you..

Weekly challenge 3

Question 1)

Primary and foreign keys are two connected identifiers within separate tables. These tables exist in what kind of database?

• Primary
• Metadata
• Relational
• Normalized

Question 2)

Metadata is data about data. What kinds of information can metadata offer about a particular dataset? Select all that apply.

• If the data is clean and reliable
• What kinds of data it contains
• Which analyses to perform on the data
• How to combine the data with another dataset

Question 3)

Think about data as a student at a high school. In this metaphor, which of the following are examples of metadata? Select all that apply.

• Student’s ID number
• Grades the student earns
• Student’s enrollment date
• Classes the student is enrolled in

Question 4)

Think about data as a refrigerator. Which kind of metadata is the refrigerator’s product number?

• Redundant
• Structural
• Descriptive
• Administrative

Question 5)

What is the process that data analysts use to ensure the formal management of their company’s data assets?

• Data mapping
• Data integrity
• Data governance
• Data aggregation

Question 6)

Describe the key differences between a star and a snowflake schema. Select all that apply.

A star schema enables very fast data processing.

• A snowflake schema enables very fast data processing.

• A star schema has one or more fact tables referencing any number of dimension tables. A snowflake schema is an extension of a star schema, with more dimensions and subdimensions.

• A snowflake schema has one or more fact tables referencing any number of dimension tables. A star schema is an extension of a snowflake schema, with more dimensions and subdimensions.

Question 7)

What are some key benefits of using external data? Select all that apply.

• External data is free to use.
• External data has broad reach.
• External data is always reliable.
• External data provides industry-level perspectives.

Question 8)

A data analyst reviews a database of Wisconsin car sales to find the last five car models sold in Milwaukee in 2019. How can they sort and filter the data to return the last five cars at the top? Select all that apply.

• Filter out sales not in 2019
• Sort by date in ascending order
• Sort by date in descending order
• Filter out sales outside of Milwaukee